TerraSafe - NOAA

Dataset statistics

Number of variables	18
Number of observations	4585
Missing cells	18100
Missing cells (%)	21.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	613.6 KiB
Average record size in memory	137.0 B

Variable types

Numeric	11
Text	2
Categorical	4
Boolean	1

Alerts

`publish` has constant value ""	Constant
`id` is highly overall correlated with `year`	High correlation
`year` is highly overall correlated with `id`	High correlation
`damageAmountOrder` is highly overall correlated with `housesDestroyedAmountOrderTotal`	High correlation
`housesDestroyedAmountOrderTotal` is highly overall correlated with `damageAmountOrder`	High correlation
`month` has 81 (1.8%) missing values	Missing
`day` has 128 (2.8%) missing values	Missing
`hour` has 747 (16.3%) missing values	Missing
`eqDepth` has 1254 (27.4%) missing values	Missing
`damageAmountOrder` has 1094 (23.9%) missing values	Missing
`damageMillionsDollars` has 4029 (87.9%) missing values	Missing
`housesDestroyedAmountOrderTotal` has 2900 (63.2%) missing values	Missing
`deathsAmountOrder` has 2487 (54.2%) missing values	Missing
`injuriesAmountOrderTotal` has 2992 (65.3%) missing values	Missing
`intensity` has 2382 (52.0%) missing values	Missing
`id` has unique values	Unique
`hour` has 185 (4.0%) zeros	Zeros

Reproduction

Analysis started	2023-06-30 04:48:20.344227
Analysis finished	2023-06-30 04:49:13.359591
Duration	53.02 seconds
Software version	ydata-profiling vv4.2.0
Download configuration	config.json

id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	4585
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5652.9954

Minimum	38
Maximum	10699
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	35.9 KiB

Quantile statistics

Minimum	38
5-th percentile	1063.6
Q1	3539
median	5351
Q3	7926
95-th percentile	10429.8
Maximum	10699
Range	10661
Interquartile range (IQR)	4387

Descriptive statistics

Standard deviation	2869.6408
Coefficient of variation (CV)	0.50763189
Kurtosis	-0.86208227
Mean	5652.9954
Median Absolute Deviation (MAD)	2104
Skewness	0.18792961
Sum	25918984
Variance	8234838.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
942	1	< 0.1%
4714	1	< 0.1%
4046	1	< 0.1%
2987	1	< 0.1%
10094	1	< 0.1%
5698	1	< 0.1%
7911	1	< 0.1%
2120	1	< 0.1%
5285	1	< 0.1%
885	1	< 0.1%
Other values (4575)	4575	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
38	1	< 0.1%
43	1	< 0.1%
60	1	< 0.1%
62	1	< 0.1%
64	1	< 0.1%
65	1	< 0.1%
66	1	< 0.1%
70	1	< 0.1%
71	1	< 0.1%
74	1	< 0.1%

Value	Count	Frequency (%)
10699	1	< 0.1%
10698	1	< 0.1%
10697	1	< 0.1%
10696	1	< 0.1%
10695	1	< 0.1%
10694	1	< 0.1%
10693	1	< 0.1%
10692	1	< 0.1%
10691	1	< 0.1%
10689	1	< 0.1%

year
Real number (ℝ)

Distinct	579
Distinct (%)	12.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1900.2595

Minimum	10
Maximum	2023
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	35.9 KiB

Quantile statistics

Minimum	10
5-th percentile	1568.4
Q1	1907
median	1968
Q3	2003
95-th percentile	2018
Maximum	2023
Range	2013
Interquartile range (IQR)	96

Descriptive statistics

Standard deviation	230.08548
Coefficient of variation (CV)	0.12108108
Kurtosis	25.2693
Mean	1900.2595
Median Absolute Deviation (MAD)	40
Skewness	-4.5949373
Sum	8712690
Variance	52939.327
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2004	78	1.7%
2008	76	1.7%
2003	72	1.6%
2018	69	1.5%
2007	67	1.5%
2017	64	1.4%
2006	63	1.4%
2010	62	1.4%
2019	61	1.3%
2009	61	1.3%
Other values (569)	3912	85.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	1	< 0.1%
27	1	< 0.1%
46	1	< 0.1%
62	1	< 0.1%
89	1	< 0.1%
100	1	< 0.1%
103	1	< 0.1%
115	1	< 0.1%
120	1	< 0.1%
123	1	< 0.1%

Value	Count	Frequency (%)
2023	24	0.5%
2022	42	0.9%
2021	42	0.9%
2020	28	0.6%
2019	61	1.3%
2018	69	1.5%
2017	64	1.4%
2016	53	1.2%
2015	48	1.0%
2014	56	1.2%

month
Real number (ℝ)

Distinct	12
Distinct (%)	0.3%
Missing	81
Missing (%)	1.8%
Infinite	0
Infinite (%)	0.0%
Mean	6.4897869

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	35.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	7
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.4449295
Coefficient of variation (CV)	0.53082322
Kurtosis	-1.2093031
Mean	6.4897869
Median Absolute Deviation (MAD)	3
Skewness	-0.0067013412
Sum	29230
Variance	11.867539
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
9	393	8.6%
8	392	8.5%
7	391	8.5%
11	388	8.5%
1	384	8.4%
5	380	8.3%
3	376	8.2%
2	370	8.1%
4	368	8.0%
12	362	7.9%
Other values (2)	700	15.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	384	8.4%
2	370	8.1%
3	376	8.2%
4	368	8.0%
5	380	8.3%
6	354	7.7%
7	391	8.5%
8	392	8.5%
9	393	8.6%
10	346	7.5%

Value	Count	Frequency (%)
12	362	7.9%
11	388	8.5%
10	346	7.5%
9	393	8.6%
8	392	8.5%
7	391	8.5%
6	354	7.7%
5	380	8.3%
4	368	8.0%
3	376	8.2%

day
Real number (ℝ)

Distinct	31
Distinct (%)	0.7%
Missing	128
Missing (%)	2.8%
Infinite	0
Infinite (%)	0.0%
Mean	15.752973

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	35.9 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.750494
Coefficient of variation (CV)	0.55548207
Kurtosis	-1.1723279
Mean	15.752973
Median Absolute Deviation (MAD)	8
Skewness	-0.01971964
Sum	70211
Variance	76.571145
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
25	183	4.0%
18	175	3.8%
1	172	3.8%
14	166	3.6%
20	165	3.6%
24	158	3.4%
9	157	3.4%
22	152	3.3%
16	151	3.3%
26	151	3.3%
Other values (21)	2827	61.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	172	3.8%
2	133	2.9%
3	141	3.1%
4	138	3.0%
5	137	3.0%
6	140	3.1%
7	140	3.1%
8	145	3.2%
9	157	3.4%
10	149	3.2%

Value	Count	Frequency (%)
31	91	2.0%
30	123	2.7%
29	131	2.9%
28	136	3.0%
27	112	2.4%
26	151	3.3%
25	183	4.0%
24	158	3.4%
23	146	3.2%
22	152	3.3%

hour
Real number (ℝ)

MISSING ZEROS

Distinct	24
Distinct (%)	0.6%
Missing	747
Missing (%)	16.3%
Infinite	0
Infinite (%)	0.0%
Mean	11.318916

Minimum	0
Maximum	23
Zeros	185
Zeros (%)	4.0%
Negative	0
Negative (%)	0.0%
Memory size	35.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5
median	11
Q3	18
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	7.0384411
Coefficient of variation (CV)	0.62182995
Kurtosis	-1.2293555
Mean	11.318916
Median Absolute Deviation (MAD)	6
Skewness	0.031659774
Sum	43442
Variance	49.539653
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
2	205	4.5%
0	185	4.0%
10	173	3.8%
21	171	3.7%
19	171	3.7%
8	166	3.6%
7	163	3.6%
23	163	3.6%
1	163	3.6%
14	162	3.5%
Other values (14)	2116	46.2%
(Missing)	747	16.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	185	4.0%
1	163	3.6%
2	205	4.5%
3	151	3.3%
4	151	3.3%
5	152	3.3%
6	152	3.3%
7	163	3.6%
8	166	3.6%
9	160	3.5%

Value	Count	Frequency (%)
23	163	3.6%
22	160	3.5%
21	171	3.7%
20	152	3.3%
19	171	3.7%
18	146	3.2%
17	161	3.5%
16	137	3.0%
15	134	2.9%
14	162	3.5%

locationName
Text

Distinct	3011
Distinct (%)	65.7%
Missing	1
Missing (%)	< 0.1%
Memory size	35.9 KiB

Length

Max length	52
Median length	40
Mean length	25.265271
Min length	4

Characters and Unicode

Total characters	115816
Distinct characters	42
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2506 ?
Unique (%)	54.7%

Sample

1st row	JAPAN: UCHIURA BAY
2nd row	JAPAN: NEAR S COAST HONSHU: KOZU-SHIMA
3rd row	RWANDA: RUBAVU; CONGO
4th row	CHINA: SHAANXI PROVINCE
5th row	PERU: CAMANA, AREQUIPA

Value	Count	Frequency (%)
china	587	4.1%
province	527	3.7%
islands	398	2.8%
japan	349	2.4%
indonesia	319	2.2%
iran	260	1.8%
new	238	1.6%
turkey	220	1.5%
island	179	1.2%
yunnan	155	1.1%
Other values (3531)	11196	77.6%

Most occurring characters

Value	Count	Frequency (%)
A	15181	13.1%
	14485	12.5%
N	9751	8.4%
I	9118	7.9%
E	6404	5.5%
S	5503	4.8%
R	5252	4.5%
O	5205	4.5%
:	4957	4.3%
L	4001	3.5%
Other values (32)	35959	31.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	93774	81.0%
Space Separator	14485	12.5%
Other Punctuation	6981	6.0%
Dash Punctuation	288	0.2%
Close Punctuation	142	0.1%
Open Punctuation	142	0.1%
Lowercase Letter	4	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	15181	16.2%
N	9751	10.4%
I	9118	9.7%
E	6404	6.8%
S	5503	5.9%
R	5252	5.6%
O	5205	5.6%
L	4001	4.3%
U	3985	4.2%
C	3833	4.1%
Other values (16)	25541	27.2%

Other Punctuation

Value	Count	Frequency (%)
:	4957	71.0%
,	1722	24.7%
;	184	2.6%
.	88	1.3%
'	28	0.4%
&	1	< 0.1%
\	1	< 0.1%

Lowercase Letter

Value	Count	Frequency (%)
o	2	50.0%
f	1	25.0%
i	1	25.0%

Close Punctuation

Value	Count	Frequency (%)
)	140	98.6%
]	2	1.4%

Open Punctuation

Value	Count	Frequency (%)
(	140	98.6%
[	2	1.4%

Space Separator

Value	Count	Frequency (%)
	14485	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	288	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	93778	81.0%
Common	22038	19.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	15181	16.2%
N	9751	10.4%
I	9118	9.7%
E	6404	6.8%
S	5503	5.9%
R	5252	5.6%
O	5205	5.6%
L	4001	4.3%
U	3985	4.2%
C	3833	4.1%
Other values (19)	25545	27.2%

Common

Value	Count	Frequency (%)
	14485	65.7%
:	4957	22.5%
,	1722	7.8%
-	288	1.3%
;	184	0.8%
)	140	0.6%
(	140	0.6%
.	88	0.4%
'	28	0.1%
[	2	< 0.1%
Other values (3)	4	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	115816	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	15181	13.1%
	14485	12.5%
N	9751	8.4%
I	9118	7.9%
E	6404	5.5%
S	5503	4.8%
R	5252	4.5%
O	5205	4.5%
:	4957	4.3%
L	4001	3.5%
Other values (32)	35959	31.0%

latitude
Real number (ℝ)

Distinct	3060
Distinct (%)	66.8%
Missing	2
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	20.361714

Minimum	-62.877
Maximum	73.122
Zeros	4
Zeros (%)	0.1%
Negative	1066
Negative (%)	23.2%
Memory size	35.9 KiB

Quantile statistics

Minimum	-62.877
5-th percentile	-27
Q1	2.5
median	29.2
Q3	38.2955
95-th percentile	46.3372
Maximum	73.122
Range	135.999
Interquartile range (IQR)	35.7955

Descriptive statistics

Standard deviation	23.914591
Coefficient of variation (CV)	1.1744881
Kurtosis	0.029625077
Mean	20.361714
Median Absolute Deviation (MAD)	11.788
Skewness	-0.89971185
Sum	93317.737
Variance	571.90765
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36	26	0.6%
40.5	25	0.5%
35.5	18	0.4%
36.5	17	0.4%
33	16	0.3%
40	16	0.3%
38.5	16	0.3%
38	16	0.3%
37.5	15	0.3%
38.1	15	0.3%
Other values (3050)	4403	96.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-62.877	1	< 0.1%
-61.825	1	< 0.1%
-60.82	1	< 0.1%
-60.532	1	< 0.1%
-60.274	1	< 0.1%
-59.5	1	< 0.1%
-59.1	1	< 0.1%
-58.893	1	< 0.1%
-58.416	1	< 0.1%
-58	1	< 0.1%

Value	Count	Frequency (%)
73.122	1	< 0.1%
66.416	1	< 0.1%
66.16	1	< 0.1%
65.17	1	< 0.1%
64.66	1	< 0.1%
64.004	1	< 0.1%
64	1	< 0.1%
63.98	1	< 0.1%
63.966	1	< 0.1%
63.9	1	< 0.1%

longitude
Real number (ℝ)

Distinct	3541
Distinct (%)	77.3%
Missing	2
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	46.044822

Minimum	-179.984
Maximum	180
Zeros	0
Zeros (%)	0.0%
Negative	1157
Negative (%)	25.2%
Memory size	35.9 KiB

Quantile statistics

Minimum	-179.984
5-th percentile	-116.4242
Q1	-0.9425
median	67.9
Q3	121.165
95-th percentile	159.2135
Maximum	180
Range	359.984
Interquartile range (IQR)	122.1075

Descriptive statistics

Standard deviation	90.923376
Coefficient of variation (CV)	1.974671
Kurtosis	-0.69385977
Mean	46.044822
Median Absolute Deviation (MAD)	55.18
Skewness	-0.64785605
Sum	211023.42
Variance	8267.0603
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-71	18	0.4%
-72	13	0.3%
102.5	12	0.3%
126.5	11	0.2%
126	11	0.2%
-79	10	0.2%
35.5	10	0.2%
120.5	10	0.2%
122	10	0.2%
-71.5	10	0.2%
Other values (3531)	4468	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-179.984	1	< 0.1%
-179.971	1	< 0.1%
-179.513	1	< 0.1%
-179	2	< 0.1%
-178.55	1	< 0.1%
-178.5	1	< 0.1%
-178.413	1	< 0.1%
-178.4	1	< 0.1%
-178.252	1	< 0.1%
-178.153	1	< 0.1%

Value	Count	Frequency (%)
180	1	< 0.1%
179.6	1	< 0.1%
179.444	1	< 0.1%
179.35	1	< 0.1%
179.2	1	< 0.1%
179.146	1	< 0.1%
179.1	1	< 0.1%
178.88	1	< 0.1%
178.87	1	< 0.1%
178.85	1	< 0.1%

eqMagnitude
Real number (ℝ)

Distinct	65
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.4463904

Minimum	1.6
Maximum	9.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	35.9 KiB

Quantile statistics

Minimum	1.6
5-th percentile	4.7
Q1	5.7
median	6.5
Q3	7.3
95-th percentile	8
Maximum	9.5
Range	7.9
Interquartile range (IQR)	1.6

Descriptive statistics

Standard deviation	1.038084
Coefficient of variation (CV)	0.16103338
Kurtosis	-0.28147376
Mean	6.4463904
Median Absolute Deviation (MAD)	0.8
Skewness	-0.28229489
Sum	29556.7
Variance	1.0776184
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.5	262	5.7%
7	238	5.2%
6	221	4.8%
6.5	204	4.4%
5.5	186	4.1%
6.8	160	3.5%
6.3	149	3.2%
7.6	148	3.2%
6.4	141	3.1%
7.3	139	3.0%
Other values (55)	2737	59.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.6	1	< 0.1%
2.1	2	< 0.1%
2.2	1	< 0.1%
2.8	1	< 0.1%
3.1	3	0.1%
3.2	4	0.1%
3.4	2	< 0.1%
3.5	4	0.1%
3.6	3	0.1%
3.7	3	0.1%

Value	Count	Frequency (%)
9.5	1	< 0.1%
9.2	1	< 0.1%
9.1	3	0.1%
9	2	< 0.1%
8.8	3	0.1%
8.7	3	0.1%
8.6	12	0.3%
8.5	18	0.4%
8.4	22	0.5%
8.3	39	0.9%

eqDepth
Real number (ℝ)

Distinct	203
Distinct (%)	6.1%
Missing	1254
Missing (%)	27.4%
Infinite	0
Infinite (%)	0.0%
Mean	40.139898

Minimum	0
Maximum	675
Zeros	12
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	35.9 KiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	10
median	24
Q3	37
95-th percentile	120
Maximum	675
Range	675
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	70.004236
Coefficient of variation (CV)	1.7440063
Kurtosis	42.988812
Mean	40.139898
Median Absolute Deviation (MAD)	14
Skewness	5.9968315
Sum	133706
Variance	4900.593
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	507	11.1%
33	370	8.1%
15	153	3.3%
60	115	2.5%
20	100	2.2%
5	94	2.1%
25	81	1.8%
30	72	1.6%
12	67	1.5%
11	64	1.4%
Other values (193)	1708	37.3%
(Missing)	1254	27.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	12	0.3%
1	15	0.3%
2	9	0.2%
3	15	0.3%
4	16	0.3%
5	94	2.1%
6	38	0.8%
7	43	0.9%
8	59	1.3%
9	45	1.0%

Value	Count	Frequency (%)
675	1	< 0.1%
670	1	< 0.1%
664	1	< 0.1%
651	1	< 0.1%
650	2	< 0.1%
640	1	< 0.1%
636	1	< 0.1%
633	1	< 0.1%
631	1	< 0.1%
629	1	< 0.1%

damageAmountOrder
Categorical

HIGH CORRELATION MISSING

Distinct	4
Distinct (%)	0.1%
Missing	1094
Missing (%)	23.9%
Memory size	35.9 KiB

2.0	1195
1.0	1027
3.0	800
4.0	469

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	10473
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	2.0
4th row	1.0
5th row	2.0

Common Values

Value	Count	Frequency (%)
2.0	1195	26.1%
1.0	1027	22.4%
3.0	800	17.4%
4.0	469	10.2%
(Missing)	1094	23.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2.0	1195	34.2%
1.0	1027	29.4%
3.0	800	22.9%
4.0	469	13.4%

Most occurring characters

Value	Count	Frequency (%)
.	3491	33.3%
0	3491	33.3%
2	1195	11.4%
1	1027	9.8%
3	800	7.6%
4	469	4.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6982	66.7%
Other Punctuation	3491	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	3491	50.0%
2	1195	17.1%
1	1027	14.7%
3	800	11.5%
4	469	6.7%

Other Punctuation

Value	Count	Frequency (%)
.	3491	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	10473	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	3491	33.3%
0	3491	33.3%
2	1195	11.4%
1	1027	9.8%
3	800	7.6%
4	469	4.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10473	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	3491	33.3%
0	3491	33.3%
2	1195	11.4%
1	1027	9.8%
3	800	7.6%
4	469	4.5%

damageMillionsDollars
Real number (ℝ)

Distinct	277
Distinct (%)	49.8%
Missing	4029
Missing (%)	87.9%
Infinite	0
Infinite (%)	0.0%
Mean	1364.7314

Minimum	0.013
Maximum	100000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	35.9 KiB

Quantile statistics

Minimum	0.013
5-th percentile	0.675
Q1	4.305
median	25
Q3	232.475
95-th percentile	5225
Maximum	100000
Range	99999.987
Interquartile range (IQR)	228.17

Descriptive statistics

Standard deviation	7434.8239
Coefficient of variation (CV)	5.4478294
Kurtosis	119.16249
Mean	1364.7314
Median Absolute Deviation (MAD)	24
Skewness	10.291632
Sum	758790.66
Variance	55276606
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5	49	1.1%
1	31	0.7%
2	15	0.3%
25	12	0.3%
100	12	0.3%
20	11	0.2%
50	9	0.2%
10	9	0.2%
0.5	9	0.2%
1000	8	0.2%
Other values (267)	391	8.5%
(Missing)	4029	87.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.013	1	< 0.1%
0.025	1	< 0.1%
0.04	1	< 0.1%
0.05	1	< 0.1%
0.1	2	< 0.1%
0.15	1	< 0.1%
0.2	2	< 0.1%
0.25	1	< 0.1%
0.3	1	< 0.1%
0.32	1	< 0.1%

Value	Count	Frequency (%)
100000	1	< 0.1%
87500	1	< 0.1%
86000	1	< 0.1%
40000	1	< 0.1%
30000	1	< 0.1%
28000	1	< 0.1%
20000	3	0.1%
16200	1	< 0.1%
15800	1	< 0.1%
15000	1	< 0.1%

publish
Boolean

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.6 KiB

True	4585

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	4585	100.0%

housesDestroyedAmountOrderTotal
Categorical

HIGH CORRELATION MISSING

Distinct	4
Distinct (%)	0.2%
Missing	2900
Missing (%)	63.2%
Memory size	35.9 KiB

3.0	622
4.0	443
1.0	359
2.0	261

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	5055
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	4.0
3rd row	1.0
4th row	1.0
5th row	3.0

Common Values

Value	Count	Frequency (%)
3.0	622	13.6%
4.0	443	9.7%
1.0	359	7.8%
2.0	261	5.7%
(Missing)	2900	63.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3.0	622	36.9%
4.0	443	26.3%
1.0	359	21.3%
2.0	261	15.5%

Most occurring characters

Value	Count	Frequency (%)
.	1685	33.3%
0	1685	33.3%
3	622	12.3%
4	443	8.8%
1	359	7.1%
2	261	5.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3370	66.7%
Other Punctuation	1685	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1685	50.0%
3	622	18.5%
4	443	13.1%
1	359	10.7%
2	261	7.7%

Other Punctuation

Value	Count	Frequency (%)
.	1685	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5055	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	1685	33.3%
0	1685	33.3%
3	622	12.3%
4	443	8.8%
1	359	7.1%
2	261	5.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5055	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	1685	33.3%
0	1685	33.3%
3	622	12.3%
4	443	8.8%
1	359	7.1%
2	261	5.2%

country
Text

Distinct	146
Distinct (%)	3.2%
Missing	1
Missing (%)	< 0.1%
Memory size	35.9 KiB

Length

Max length	44
Median length	30
Mean length	7.0543194
Min length	2

Characters and Unicode

Total characters	32337
Distinct characters	33
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24 ?
Unique (%)	0.5%

Sample

1st row	JAPAN
2nd row	JAPAN
3rd row	RWANDA
4th row	CHINA
5th row	PERU

Value	Count	Frequency (%)
china	584	11.2%
japan	349	6.7%
indonesia	329	6.3%
iran	258	4.9%
usa	245	4.7%
turkey	214	4.1%
new	203	3.9%
peru	153	2.9%
greece	150	2.9%
chile	146	2.8%
Other values (155)	2601	49.7%

Most occurring characters

Value	Count	Frequency (%)
A	5357	16.6%
I	3750	11.6%
N	3587	11.1%
E	2634	8.1%
S	1669	5.2%
R	1612	5.0%
U	1422	4.4%
C	1414	4.4%
O	1291	4.0%
P	1247	3.9%
Other values (23)	8354	25.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	31558	97.6%
Space Separator	648	2.0%
Open Punctuation	57	0.2%
Close Punctuation	57	0.2%
Dash Punctuation	9	< 0.1%
Other Punctuation	8	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	5357	17.0%
I	3750	11.9%
N	3587	11.4%
E	2634	8.3%
S	1669	5.3%
R	1612	5.1%
U	1422	4.5%
C	1414	4.5%
O	1291	4.1%
P	1247	4.0%
Other values (16)	7575	24.0%

Other Punctuation

Value	Count	Frequency (%)
,	3	37.5%
.	3	37.5%
'	2	25.0%

Space Separator

Value	Count	Frequency (%)
	648	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	57	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	57	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	9	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	31558	97.6%
Common	779	2.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	5357	17.0%
I	3750	11.9%
N	3587	11.4%
E	2634	8.3%
S	1669	5.3%
R	1612	5.1%
U	1422	4.5%
C	1414	4.5%
O	1291	4.1%
P	1247	4.0%
Other values (16)	7575	24.0%

Common

Value	Count	Frequency (%)
	648	83.2%
(	57	7.3%
)	57	7.3%
-	9	1.2%
,	3	0.4%
.	3	0.4%
'	2	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	32337	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	5357	16.6%
I	3750	11.6%
N	3587	11.1%
E	2634	8.1%
S	1669	5.2%
R	1612	5.0%
U	1422	4.4%
C	1414	4.4%
O	1291	4.0%
P	1247	3.9%
Other values (23)	8354	25.8%

deathsAmountOrder
Categorical

Distinct	5
Distinct (%)	0.2%
Missing	2487
Missing (%)	54.2%
Memory size	35.9 KiB

1.0	1255
3.0	397
4.0	254
2.0	191
0.0	1

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	6294
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	2.0

Common Values

Value	Count	Frequency (%)
1.0	1255	27.4%
3.0	397	8.7%
4.0	254	5.5%
2.0	191	4.2%
0.0	1	< 0.1%
(Missing)	2487	54.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	1255	59.8%
3.0	397	18.9%
4.0	254	12.1%
2.0	191	9.1%
0.0	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	2099	33.3%
.	2098	33.3%
1	1255	19.9%
3	397	6.3%
4	254	4.0%
2	191	3.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	4196	66.7%
Other Punctuation	2098	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2099	50.0%
1	1255	29.9%
3	397	9.5%
4	254	6.1%
2	191	4.6%

Other Punctuation

Value	Count	Frequency (%)
.	2098	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	6294	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2099	33.3%
.	2098	33.3%
1	1255	19.9%
3	397	6.3%
4	254	4.0%
2	191	3.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6294	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2099	33.3%
.	2098	33.3%
1	1255	19.9%
3	397	6.3%
4	254	4.0%
2	191	3.0%

injuriesAmountOrderTotal
Categorical

Distinct	4
Distinct (%)	0.3%
Missing	2992
Missing (%)	65.3%
Memory size	35.9 KiB

1.0	807
3.0	406
2.0	221
4.0	159

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	4779
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3.0
2nd row	1.0
3rd row	1.0
4th row	3.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	807	17.6%
3.0	406	8.9%
2.0	221	4.8%
4.0	159	3.5%
(Missing)	2992	65.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	807	50.7%
3.0	406	25.5%
2.0	221	13.9%
4.0	159	10.0%

Most occurring characters

Value	Count	Frequency (%)
.	1593	33.3%
0	1593	33.3%
1	807	16.9%
3	406	8.5%
2	221	4.6%
4	159	3.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3186	66.7%
Other Punctuation	1593	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1593	50.0%
1	807	25.3%
3	406	12.7%
2	221	6.9%
4	159	5.0%

Other Punctuation

Value	Count	Frequency (%)
.	1593	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	4779	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	1593	33.3%
0	1593	33.3%
1	807	16.9%
3	406	8.5%
2	221	4.6%
4	159	3.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4779	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	1593	33.3%
0	1593	33.3%
1	807	16.9%
3	406	8.5%
2	221	4.6%
4	159	3.3%

intensity
Real number (ℝ)

Distinct	11
Distinct (%)	0.5%
Missing	2382
Missing (%)	52.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.8565592

Minimum	2
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	35.9 KiB

Quantile statistics

Minimum	2
5-th percentile	5
Q1	7
median	8
Q3	9
95-th percentile	10
Maximum	12
Range	10
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.7197724
Coefficient of variation (CV)	0.21889638
Kurtosis	0.19098803
Mean	7.8565592
Median Absolute Deviation (MAD)	1
Skewness	-0.40883737
Sum	17308
Variance	2.957617
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
8	553	12.1%
7	445	9.7%
9	393	8.6%
10	294	6.4%
6	220	4.8%
5	114	2.5%
11	91	2.0%
4	58	1.3%
3	19	0.4%
2	8	0.2%
(Missing)	2382	52.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	8	0.2%
3	19	0.4%
4	58	1.3%
5	114	2.5%
6	220	4.8%
7	445	9.7%
8	553	12.1%
9	393	8.6%
10	294	6.4%
11	91	2.0%

Value	Count	Frequency (%)
12	8	0.2%
11	91	2.0%
10	294	6.4%
9	393	8.6%
8	553	12.1%
7	445	9.7%
6	220	4.8%
5	114	2.5%
4	58	1.3%
3	19	0.4%

Auto

Heatmap
Table

	id	year	month	day	hour	latitude	longitude	eqMagnitude	eqDepth	damageMillionsDollars	intensity	damageAmountOrder	housesDestroyedAmountOrderTotal	deathsAmountOrder	injuriesAmountOrderTotal
id	1.000	0.704	0.007	-0.008	0.026	-0.110	0.076	-0.324	-0.253	0.316	-0.486	0.245	0.201	0.247	0.163
year	0.704	1.000	-0.014	-0.005	0.011	-0.128	-0.017	-0.322	-0.299	0.352	-0.427	0.113	0.072	0.199	0.039
month	0.007	-0.014	1.000	0.022	0.003	-0.026	0.034	0.029	-0.013	-0.010	-0.021	0.000	0.000	0.000	0.000
day	-0.008	-0.005	0.022	1.000	0.014	0.016	-0.015	0.011	-0.002	0.014	-0.003	0.000	0.052	0.027	0.027
hour	0.026	0.011	0.003	0.014	1.000	-0.012	-0.011	0.010	0.010	0.013	-0.063	0.000	0.017	0.036	0.000
latitude	-0.110	-0.128	-0.026	0.016	-0.012	1.000	-0.030	-0.212	-0.237	0.145	0.135	0.106	0.128	0.088	0.020
longitude	0.076	-0.017	0.034	-0.015	-0.011	-0.030	1.000	0.106	0.101	0.051	-0.103	0.113	0.123	0.081	0.066
eqMagnitude	-0.324	-0.322	0.029	0.011	0.010	-0.212	0.106	1.000	0.418	0.195	0.426	0.167	0.142	0.160	0.197
eqDepth	-0.253	-0.299	-0.013	-0.002	0.010	-0.237	0.101	0.418	1.000	-0.150	0.002	0.029	0.064	0.000	0.000
damageMillionsDollars	0.316	0.352	-0.010	0.014	0.013	0.145	0.051	0.195	-0.150	1.000	0.294	0.000	0.000	0.122	0.109
intensity	-0.486	-0.427	-0.021	-0.003	-0.063	0.135	-0.103	0.426	0.002	0.294	1.000	0.285	0.267	0.271	0.233
damageAmountOrder	0.245	0.113	0.000	0.000	0.000	0.106	0.113	0.167	0.029	0.000	0.285	1.000	0.501	0.319	0.360
housesDestroyedAmountOrderTotal	0.201	0.072	0.000	0.052	0.017	0.128	0.123	0.142	0.064	0.000	0.267	0.501	1.000	0.281	0.329
deathsAmountOrder	0.247	0.199	0.000	0.027	0.036	0.088	0.081	0.160	0.000	0.122	0.271	0.319	0.281	1.000	0.439
injuriesAmountOrderTotal	0.163	0.039	0.000	0.027	0.000	0.020	0.066	0.197	0.000	0.109	0.233	0.360	0.329	0.439	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	id	year	month	day	hour	locationName	latitude	longitude	eqMagnitude	eqDepth	damageAmountOrder	damageMillionsDollars	publish	housesDestroyedAmountOrderTotal	country	deathsAmountOrder	injuriesAmountOrderTotal	intensity
0	942	1640	7.0	31.0	NaN	JAPAN: UCHIURA BAY	42.070	140.680	6.5	NaN	1.0	NaN	True	1.0	JAPAN	NaN	NaN	NaN
1	5568	2000	7.0	1.0	7.0	JAPAN: NEAR S COAST HONSHU: KOZU-SHIMA	34.221	139.131	6.1	10.0	1.0	NaN	True	NaN	JAPAN	1.0	3.0	NaN
2	10545	2021	5.0	25.0	9.0	RWANDA: RUBAVU; CONGO	-1.601	29.400	4.7	10.0	2.0	NaN	True	4.0	RWANDA	NaN	NaN	7.0
3	8051	1959	8.0	10.0	23.0	CHINA: SHAANXI PROVINCE	35.600	110.900	5.4	NaN	1.0	NaN	True	1.0	CHINA	NaN	NaN	7.0
4	5520	1999	4.0	3.0	6.0	PERU: CAMANA, AREQUIPA	-16.660	-72.662	6.8	87.0	2.0	NaN	True	NaN	PERU	1.0	1.0	6.0
5	9552	2010	9.0	27.0	11.0	IRAN: SHIRAZ	29.647	51.665	5.8	27.0	1.0	NaN	True	1.0	IRAN	1.0	1.0	NaN
6	2866	1909	5.0	11.0	15.0	CHINA: YUNNAN PROVINCE	24.400	103.000	6.5	NaN	2.0	NaN	True	3.0	CHINA	1.0	NaN	8.0
7	5433	1996	2.0	17.0	5.0	INDONESIA: NEW GUINEA: IRIAN JAYA: BIAK, SUPIORI	-0.891	136.952	8.2	33.0	2.0	4.2	True	4.0	INDONESIA	2.0	3.0	9.0
8	8130	2008	5.0	7.0	16.0	JAPAN: HONSHU: E COAST	36.158	141.521	6.8	39.0	1.0	NaN	True	NaN	JAPAN	NaN	1.0	NaN
9	2419	1892	5.0	16.0	11.0	GUAM	14.000	143.300	7.5	NaN	2.0	NaN	True	1.0	USA TERRITORY	NaN	NaN	8.0

	id	year	month	day	hour	locationName	latitude	longitude	eqMagnitude	eqDepth	damageAmountOrder	damageMillionsDollars	publish	housesDestroyedAmountOrderTotal	country	deathsAmountOrder	injuriesAmountOrderTotal	intensity
4575	5712	2003	8.0	4.0	4.0	SCOTIA SEA: SOUTH ORKNEY ISLANDS: LAURIE IS	-60.532	-43.411	7.6	10.0	1.0	NaN	True	NaN	ANTARCTICA	NaN	NaN	NaN
4576	2819	1907	10.0	16.0	14.0	MEXICO: GULF OF CALIFORNIA	28.000	-112.500	7.7	60.0	NaN	NaN	True	NaN	MEXICO	NaN	NaN	NaN
4577	1185	1713	2.0	26.0	NaN	CHINA: YUNNAN PROVINCE: S OF XUNDIAN	25.400	103.200	6.8	NaN	4.0	NaN	True	4.0	CHINA	4.0	NaN	9.0
4578	4824	1978	12.0	23.0	11.0	TAIWAN: PINTUNG	23.247	122.075	7.0	33.0	NaN	NaN	True	NaN	TAIWAN	1.0	1.0	NaN
4579	3697	1942	4.0	8.0	15.0	PHILIPPINES: MINDORO	13.500	121.000	7.8	25.0	NaN	NaN	True	NaN	PHILIPPINES	NaN	NaN	NaN
4580	626	1471	NaN	NaN	NaN	PERU	-16.300	-71.000	8.0	25.0	NaN	NaN	True	NaN	PERU	NaN	NaN	9.0
4581	6408	1963	12.0	16.0	1.0	INDONESIA: JAVA: LABUHAN, MENES, PONOROGO	-6.400	105.400	6.6	64.0	1.0	NaN	True	NaN	INDONESIA	NaN	NaN	NaN
4582	8161	2008	10.0	6.0	8.0	CHINA: TIBET (XIZANG PROVINCE)	29.807	90.350	6.3	12.0	2.0	NaN	True	3.0	CHINA	1.0	1.0	NaN
4583	777	1582	8.0	15.0	NaN	PERU	-12.200	-77.600	7.8	30.0	NaN	NaN	True	NaN	PERU	NaN	NaN	7.0
4584	2838	1908	10.0	23.0	20.0	AFGHANISTAN: HINDU KUSH	36.500	70.500	7.0	220.0	NaN	NaN	True	NaN	AFGHANISTAN	NaN	NaN	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Other Punctuation

Lowercase Letter

Close Punctuation

Open Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Other Punctuation

Space Separator

Open Punctuation

Close Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)